CREATE TABLE log_trace
(
	id					INTEGER,
	type				VARCHAR2(7),
	source			VARCHAR2(256),
	text				VARCHAR2(4000),
	parameters	VARCHAR2(4000),
	dttm 				DATE DEFAULT SYSDATE, -- TIMESTAMP(3) DEFAULT SYSTIMESTAMP,
	CONSTRAINT log_trace_pk PRIMARY KEY (id) USING INDEX
		(CREATE UNIQUE INDEX log_trace_pk_idx ON log_trace(id ASC)),
	CONSTRAINT log_trace_type_chk
  	CHECK ( type in ('DEBUG','INFO','WARNING','ERROR','FATAL') )
);

CREATE INDEX log_trace_dttm_idx
	ON log_trace(dttm ASC);

--GRANT SELECT ON log_trace TO PUBLIC;
--CREATE PUBLIC SYNONYM log_trace FOR log_trace;
